UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8hfQxQ9gKFwReBy9b6N5eP6SFolz+O8gjg2Z0k18N0='
WHERE
key_id = '0c28089a8ca7ec16f70ab6f4c66dbb6c755d989396ac5899c3acf778c8661f18'
AND (
token = 'p8hfQxQ9gKFwReBy9b6N5eP6SFolz+O8gjg2Z0k18N0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)