UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w8BgJdPiBCLc3eEOxPptMLIdP4L+aC02Gj6yXIdugF8='
WHERE
key_id = '0ab63c8b9db6a6162d4e25e7a948a3d1a9d90c82b10fc38dc5c571c5fd2175a4'
AND (
token = 'w8BgJdPiBCLc3eEOxPptMLIdP4L+aC02Gj6yXIdugF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)