UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YDxi9PWjMM5eC4VvJTUDJ14/xCv2s0mHKG3zHNJahGk='
WHERE
key_id = '9bab3b88d3c713228411e2842d5274ab114bb9eee4d474947f6e201f605fb8b9'
AND (
token = 'YDxi9PWjMM5eC4VvJTUDJ14/xCv2s0mHKG3zHNJahGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)