UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PMij5xvPleiiApngDrLIr/gXhcA/49XNkb2B0wQx/HY='
WHERE
key_id = '0bc9f075b20c5d2d6af88ccc4f2feb2fbdeb583b6ebb0f275ce7d0a945190ccf'
AND (
token = 'PMij5xvPleiiApngDrLIr/gXhcA/49XNkb2B0wQx/HY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)