UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HICdcD0m1ywy+4ni4NGD7QvYGl/syxD3o59vSTw9OmI='
WHERE
key_id = '8c0fab0851d1927d807e57de6e4dfb613fd3747e2d771f253b4960260002d1f3'
AND (
token = 'HICdcD0m1ywy+4ni4NGD7QvYGl/syxD3o59vSTw9OmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)