UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cLgy46zwQKXSQ2Fw4E729/+/ET8bmn11SaQyI/q2pOo='
WHERE
key_id = '460e18cf5038c5f21de6c25fb17d8f39ae3c43874ce516e89f90ef2c3264ee75'
AND (
token = 'cLgy46zwQKXSQ2Fw4E729/+/ET8bmn11SaQyI/q2pOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)