UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hyiS1CWdQjP82nf0frZ+eiYgrMIeHr50tgsv41IUzWM='
WHERE
key_id = 'bdf4a4dcf1424d22aa0c0424a9732e772fb470224bf140e039e07a2a85af790a'
AND (
token = 'hyiS1CWdQjP82nf0frZ+eiYgrMIeHr50tgsv41IUzWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)