UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R1PSX1a5U3GX0pFA2/zIDeEhlpEPG0+8S+YK9zLpdSA='
WHERE
key_id = '9b4d8d12d5f3d8f7cca4c9c6104c76c8b9166959261cee928e3e6be880dcf6fc'
AND (
token = 'R1PSX1a5U3GX0pFA2/zIDeEhlpEPG0+8S+YK9zLpdSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)