UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LoBhqDs4nzqPpudeCQZsHfRSotxJykuiayX4FA+CBXE='
WHERE
key_id = '38de0c1507c11f13278926ce4531d3ac6c22d19ccde4efcb7d60387634d28302'
AND (
token = 'LoBhqDs4nzqPpudeCQZsHfRSotxJykuiayX4FA+CBXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)