UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NG3QkB5xKZUwcSY9TCD3ne5l/5FK/9RBN92ta2gOWOU='
WHERE
key_id = 'd4f4485a4d910747c5fc26e7b11f62e08f2fdac7d5ccaef74cc40ee4174f562f'
AND (
token = 'NG3QkB5xKZUwcSY9TCD3ne5l/5FK/9RBN92ta2gOWOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)