UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CIdcUy6X2/wWNt6ML6yO8ShDz8cCHvhEaO+4pygSKhA='
WHERE
key_id = 'bfb51353e7d0458aaa80aa9a2f44353550179cf5332fa0b915a5ebfb4afadf70'
AND (
token = 'CIdcUy6X2/wWNt6ML6yO8ShDz8cCHvhEaO+4pygSKhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)