UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/qsY9aucZTrPnPRXDb0XwkgSDkvAeF107fOzYMmHrzw='
WHERE
key_id = '7bba55146c9c00e2db843a512b0a5a2a6bab4fd7a98e96bb6df1d918dbb92ade'
AND (
token = '/qsY9aucZTrPnPRXDb0XwkgSDkvAeF107fOzYMmHrzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)