UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pxbFJ6zbWNqr5EcG3hoZFOn8s73HZgArI3ud0xjHiAE='
WHERE
key_id = '7bfa8ddbbe794f064c3cadc9a4ccc1e1ec4c012972ec03074ad58e83a688e872'
AND (
token = 'pxbFJ6zbWNqr5EcG3hoZFOn8s73HZgArI3ud0xjHiAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)