UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bWfphEFRtVI74h4wqL02NdVDGonj0iRRXtwigDIlSV8='
WHERE
key_id = '4dcd72ccfc68cfe233b39ec87a9a4d053f09ad3cabab439c9c8c56a77e29eb71'
AND (
token = 'bWfphEFRtVI74h4wqL02NdVDGonj0iRRXtwigDIlSV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)