UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n7LlJvPx5CBbOjQtttx1GxdHbzKYH4YMVRwb88BYNSw='
WHERE
key_id = 'd435316b4a25b933e361900b95a2dbf582a0f3fa310f7836c614189f40deec2f'
AND (
token = 'n7LlJvPx5CBbOjQtttx1GxdHbzKYH4YMVRwb88BYNSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)