UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vIK2Ab1jA8ws59uK/e75/XD/Hvd1Jml64JRW5RoRlDc='
WHERE
key_id = 'eed00fafe3c27d0afbcbc30bfc1f9c0fef14d946173297354f2b2681c14de9af'
AND (
token = 'vIK2Ab1jA8ws59uK/e75/XD/Hvd1Jml64JRW5RoRlDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)