UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q/cX1fU/2uaNYGKkDSUrtTNIZAK6p1B9xTZu5OPqeGw='
WHERE
key_id = 'c8d29fcbf0efc0978b76040e9418e96cc69111f0d638763b40d965d788ea83bf'
AND (
token = 'q/cX1fU/2uaNYGKkDSUrtTNIZAK6p1B9xTZu5OPqeGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)