UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BrwYsJlq1d9gczQE+MPYJKtVIGl4fYJh5aSX2KmijHA='
WHERE
key_id = 'afa826c6913e49f13b7fbfd3cb33369da83e9297e42f56c713f4b3afc11ba4f6'
AND (
token = 'BrwYsJlq1d9gczQE+MPYJKtVIGl4fYJh5aSX2KmijHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)