UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xP/Xjh9Jl1fnZtjw/SAFSI69varSCAzxqIoIgOitxA0='
WHERE
key_id = '9c5fdd0f11c158266e33a1091d8f4f088523b16591132d49a89f9df0112d9bda'
AND (
token = 'xP/Xjh9Jl1fnZtjw/SAFSI69varSCAzxqIoIgOitxA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)