UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gETcrTVSXkXH+zRVzy33i6EdqzC4oy0psEgxRZnrCs='
WHERE
key_id = '9bc9761c45b08f475e8fe799a63d2a1f06f03aa1db54874a0035640a1ffec466'
AND (
token = '6gETcrTVSXkXH+zRVzy33i6EdqzC4oy0psEgxRZnrCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)