UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'awpRdbUVMdImZUMvYoC1dZbf1gIGeJLyBpV18+ywFSY='
WHERE
key_id = 'b7f23a8781abe640c6ddefe7b05cf9d1bd2b73e37c028ec89fd7fc152f07b36e'
AND (
token = 'awpRdbUVMdImZUMvYoC1dZbf1gIGeJLyBpV18+ywFSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)