UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZX6RmZ+Hjy/b6b+CO8XBrs7bbGlsUYNtAvd0z1Jiyp0='
WHERE
key_id = '15daddac4a7299750a1dbc99454cb286347cab27a5955402a88e144d2cbcc98a'
AND (
token = 'ZX6RmZ+Hjy/b6b+CO8XBrs7bbGlsUYNtAvd0z1Jiyp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)