UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZI1r66oyUgvNYmV6VY0j6UXt6F440D+9mQtZt68YlIk='
WHERE
key_id = '503c6afe66a03356bc17d4ce879a0a13b4b4c04f9fe5a06bae51676467fb89b0'
AND (
token = 'ZI1r66oyUgvNYmV6VY0j6UXt6F440D+9mQtZt68YlIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)