UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Snz5wjEzZ675AEBm0V0WQJNRzsOyUIuih3EoJ4uTjbg='
WHERE
key_id = '387e4b20269b23402f09f305a2caa12facb3f3fdf80feea86846ae53109f9e91'
AND (
token = 'Snz5wjEzZ675AEBm0V0WQJNRzsOyUIuih3EoJ4uTjbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)