UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piqGtAjpKNwX5X0GqNmqi3+vo6dY/jZZs1krZLy4rLQ='
WHERE
key_id = '9dcf5b09bcf2a42751ba1c8785345369e8c2864e88992dad76931fdf3d8e1354'
AND (
token = 'piqGtAjpKNwX5X0GqNmqi3+vo6dY/jZZs1krZLy4rLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)