UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w7aphVsuLr5dTJB8ZimSlwo5WLcJLEAfvdDKQbG57hQ='
WHERE
key_id = '75198d9078cd5c09015333f3e161809d1ef041318ef47419610aa1add764867d'
AND (
token = 'w7aphVsuLr5dTJB8ZimSlwo5WLcJLEAfvdDKQbG57hQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)