UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1YE1jfty/UCbV9cSID0lyL6348ukhawOPe0/UoEY8g='
WHERE
key_id = '29cca81c20a3b63e72482caab11649debf008d590385b98346d8abadb921f888'
AND (
token = 'z1YE1jfty/UCbV9cSID0lyL6348ukhawOPe0/UoEY8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)