UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCDugnl7Toq3QgMPEfcTLGfr4sqrwNV4Ypk1638zxX8='
WHERE
key_id = '5e9f7724c3fd21433257715d04f13c11d5aef297981bec9ad1f180f2df76f726'
AND (
token = 'gCDugnl7Toq3QgMPEfcTLGfr4sqrwNV4Ypk1638zxX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)