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